[dbo].[BAEHistoryUpdate]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEHistoryUpdate
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@HistoryID
int
4
@EventDate
datetime
8
@IP
varchar(128)
128
@Description
varchar(1024)
1024
@EventType
varchar(256)
256
SQL Script
create
procedure
[dbo]
.
[BAEHistoryUpdate]
@HistoryID
as
int
,
@EventDate
AS
datetime
,
@IP
AS
varchar
(
128
),
@Description
AS
varchar
(
1024
),
@EventType
AS
varchar
(
256
)
AS
UPDATE
History
SET
EventDate
=
@EventDate
,
IP
=
@IP
,
Description
=
@Description
,
EventType
=
@EventType
WHERE
HistoryID
=
@HistoryID
;
GO
Uses
[dbo].[History]
dbo